CREATE TABLE [FR_LOG_EVENT_2] (
	[LOG_ID] [int] IDENTITY NOT NULL ,
	[LOG_DATA] [smalldatetime] NULL ,
	[LOG_HORA] [char] (8) COLLATE Latin1_General_CI_AS NULL ,
	[LOG_CODFORM] [int] NULL ,
	[LOG_DESCFORM] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[LOG_OPERACAO] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
	[LOG_USUARIO] [varchar] (30) COLLATE Latin1_General_CI_AS NULL ,
	[LOG_SISTEMA] [char] (3) COLLATE Latin1_General_CI_AS NULL ,
	[LOG_CHAVE] [varchar] (200) COLLATE Latin1_General_CI_AS NULL ,
	[LOG_CHAVECONT] [varchar] (128) COLLATE Latin1_General_CI_AS NULL ,
	[LOG_CONTEUDO] [text] COLLATE Latin1_General_CI_AS NULL ,
	CONSTRAINT [PK_FR_LOG_EVENT_2] PRIMARY KEY  CLUSTERED 
	(
		[LOG_ID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SET IDENTITY_INSERT FR_LOG_EVENT_2 ON

INSERT INTO FR_LOG_EVENT_2 
  ([LOG_ID], [LOG_DATA], [LOG_HORA], [LOG_CODFORM], [LOG_DESCFORM], [LOG_OPERACAO], 
   [LOG_USUARIO], [LOG_SISTEMA], [LOG_CHAVE], [LOG_CHAVECONT], [LOG_CONTEUDO])
SELECT 
   [LOG_ID], [LOG_DATA], [LOG_HORA], [LOG_CODFORM], [LOG_DESCFORM], [LOG_OPERACAO], 
   [LOG_USUARIO], [LOG_SISTEMA], [LOG_CHAVE], [LOG_CHAVECONT], [LOG_CONTEUDO]
FROM 
   FR_LOG_EVENT

SET IDENTITY_INSERT FR_LOG_EVENT_2 OFF

DROP TABLE FR_LOG_EVENT

EXECUTE sp_rename 'FR_LOG_EVENT_2', 'FR_LOG_EVENT'

